-- ----------------------------- 2023-08-06 add by hul--------------begin

-- 建表语句
CREATE TABLE T_LIMS_HOSPITAL( 
    ID NUMBER NOT NULL,
    HOSPITALCODE VARCHAR2(33)  NULL,
    HOSPITALNAME VARCHAR2(99)  NULL,
    PHONE VARCHAR2(33)  NULL,
    ADDRESS VARCHAR2(99)  NULL,
    REMARK VARCHAR2(300)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_HOSPITAL IS '医院管理';
COMMENT ON COLUMN T_LIMS_HOSPITAL.ID IS '主键';
COMMENT ON COLUMN T_LIMS_HOSPITAL.HOSPITALCODE IS '医院编号';
COMMENT ON COLUMN T_LIMS_HOSPITAL.HOSPITALNAME IS '医院名称';
COMMENT ON COLUMN T_LIMS_HOSPITAL.PHONE IS '联系电话';
COMMENT ON COLUMN T_LIMS_HOSPITAL.ADDRESS IS '地址';
COMMENT ON COLUMN T_LIMS_HOSPITAL.REMARK IS '备注';
COMMENT ON COLUMN T_LIMS_HOSPITAL.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_HOSPITAL.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_HOSPITAL.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_HOSPITAL.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_HOSPITAL.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_HOSPITAL ADD CONSTRAINT PK_LIMS_HOSPITAL PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','HOSPITALCODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','HOSPITALNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','PHONE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','ADDRESS','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','REMARK','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','HOSPITALCODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','HOSPITALNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','PHONE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','ADDRESS','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','REMARK','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL','CREATEDBYORGNAME','1');
COMMIT;
CREATE TABLE T_LIMS_HOSPITAL_INTERFACE( 
    ID NUMBER NOT NULL,
    HOSPITALID NUMBER NULL,
    APIID NUMBER NULL,
    APICODE VARCHAR2(33)  NULL,
    APINAME VARCHAR2(33)  NULL,
    APITYPE VARCHAR2(33)  NULL,
    PARAMS VARCHAR2(33)  NULL,
    HANDLEMETHOD VARCHAR2(99)  NULL,
    RESULTHANDLEMETHOD VARCHAR2(99)  NULL,
    OPERATION VARCHAR2(33)  NULL,
    REMARK VARCHAR2(99)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_HOSPITAL_INTERFACE IS '医院接口';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.ID IS '主键';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.HOSPITALID IS '医院Id';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.APIID IS '接口Id';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.APICODE IS '接口编码';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.APINAME IS '接口名称';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.APITYPE IS '接口类型';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.PARAMS IS '参数';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.HANDLEMETHOD IS '接口调用方法';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.RESULTHANDLEMETHOD IS '结果处理方式';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.OPERATION IS 'wsdl 方法名';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.REMARK IS '备注';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_HOSPITAL_INTERFACE ADD CONSTRAINT PK_LIMS_HOSPITAL_INTERFACE PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','HOSPITALID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','APIID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','APICODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','APINAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','APITYPE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','PARAMS','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','HANDLEMETHOD','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','RESULTHANDLEMETHOD','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','OPERATION','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','REMARK','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','HOSPITALID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','APIID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','APICODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','APINAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','APITYPE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','PARAMS','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','HANDLEMETHOD','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','RESULTHANDLEMETHOD','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','OPERATION','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','REMARK','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE','CREATEDBYORGNAME','1');
COMMIT;
CREATE TABLE T_LIMS_INTERFACE_SOURCE( 
    ID NUMBER NOT NULL,
    INTERFACEID NUMBER NULL,
    SOURCECODE VARCHAR2(33)  NULL,
    PARENTSOURCECODE VARCHAR2(33)  NULL,
    SOURCENAME VARCHAR2(33)  NULL,
    SOURCETABLE VARCHAR2(33)  NULL,
    SOURCETYPE VARCHAR2(33)  NULL,
    SQL CLOB NULL,
    PARAM VARCHAR2(99)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_INTERFACE_SOURCE IS '接口数据源';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.ID IS '主键';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.INTERFACEID IS '接口Id';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.SOURCECODE IS '数据源编号';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.PARENTSOURCECODE IS '父数据源编号';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.SOURCENAME IS '数据源名称';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.SOURCETABLE IS '数据源表';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.SOURCETYPE IS '数据源类型';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.SQL IS 'sql';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.PARAM IS '查询参数';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_INTERFACE_SOURCE ADD CONSTRAINT PK_LIMS_INTERFACE_SOURCE PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','INTERFACEID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','SOURCECODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','PARENTSOURCECODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','SOURCENAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','SOURCETABLE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','SOURCETYPE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','SQL','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','PARAM','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','INTERFACEID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','SOURCECODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','PARENTSOURCECODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','SOURCENAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','SOURCETABLE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','SOURCETYPE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','SQL','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','PARAM','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE','CREATEDBYORGNAME','1');
COMMIT;
CREATE TABLE 
 -- WARNING NAME T_LIMS_INTERFACE_SOURCE_COLUMN TOO LONG FOR ORACLE VERSION < 12.2 
T_LIMS_INTERFACE_SOURCE_COLUMN( 
    ID NUMBER NOT NULL,
    SOURCEID NUMBER NULL,
    COLUMNNAME VARCHAR2(33)  NULL,
    COLUMNDESC VARCHAR2(66)  NULL,
    REMARK VARCHAR2(66)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_INTERFACE_SOURCE_COLUMN IS '接口数据源列';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE_COLUMN.ID IS '主键';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE_COLUMN.SOURCEID IS '数据源Id';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE_COLUMN.COLUMNNAME IS '列名';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE_COLUMN.COLUMNDESC IS '列描述';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE_COLUMN.REMARK IS '备注';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE_COLUMN.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE_COLUMN.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE_COLUMN.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE_COLUMN.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_INTERFACE_SOURCE_COLUMN.CREATEDBYORGNAME IS '制单人单位名称';

 -- WARNING NAME PK_LIMS_INTERFACE_SOURCE_COLUMN TOO LONG FOR ORACLE VERSION < 12.2 

ALTER TABLE T_LIMS_INTERFACE_SOURCE_COLUMN ADD CONSTRAINT PK_LIMS_INTERFACE_SOURCE_COLUMN PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','SOURCEID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','COLUMNNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','COLUMNDESC','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','REMARK','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','SOURCEID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','COLUMNNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','COLUMNDESC','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','REMARK','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_INTERFACE_SOURCE_COLUMN','CREATEDBYORGNAME','1');
COMMIT;
CREATE TABLE 
 -- WARNING NAME T_LIMS_HOSPITAL_INTERFACE_PARAMS TOO LONG FOR ORACLE VERSION < 12.2 
T_LIMS_HOSPITAL_INTERFACE_PARAMS( 
    ID NUMBER NOT NULL,
    INTERFACEID NUMBER NULL,
    INDEX VARCHAR2(33)  NULL,
    PARAM VARCHAR2(33)  NULL,
    TYPE VARCHAR2(33)  NULL,
    VALUE VARCHAR2(33)  NULL,
    CATEGORY VARCHAR2(33)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_HOSPITAL_INTERFACE_PARAMS IS '接口参数';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.ID IS '主键';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.INTERFACEID IS '接口Id';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.INDEX IS '序号';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.PARAM IS '参数';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.TYPE IS '类型';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.VALUE IS '值';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.CATEGORY IS '类别';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_PARAMS.CREATEDBYORGNAME IS '制单人单位名称';

 -- WARNING NAME PK_LIMS_HOSPITAL_INTERFACE_PARAMS TOO LONG FOR ORACLE VERSION < 12.2 

ALTER TABLE T_LIMS_HOSPITAL_INTERFACE_PARAMS ADD CONSTRAINT PK_LIMS_HOSPITAL_INTERFACE_PARAMS PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','INTERFACEID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','INDEX','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','PARAM','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','TYPE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','VALUE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CATEGORY','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','INTERFACEID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','INDEX','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','PARAM','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','TYPE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','VALUE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CATEGORY','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_PARAMS','CREATEDBYORGNAME','1');
COMMIT;
CREATE TABLE T_LIMS_HOSPITAL_INTERFACE_LOG( 
    ID NUMBER NOT NULL,
    INTERFACEID NUMBER NULL,
    PARAMS VARCHAR2(100)  NULL,
    RESULT CLOB NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_HOSPITAL_INTERFACE_LOG IS '接口日志';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_LOG.ID IS '主键';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_LOG.INTERFACEID IS '接口ID';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_LOG.PARAMS IS '参数';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_LOG.RESULT IS '结果';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_LOG.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_LOG.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_LOG.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_LOG.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_HOSPITAL_INTERFACE_LOG.CREATEDBYORGNAME IS '制单人单位名称';

 -- WARNING NAME PK_LIMS_HOSPITAL_INTERFACE_LOG TOO LONG FOR ORACLE VERSION < 12.2 

ALTER TABLE T_LIMS_HOSPITAL_INTERFACE_LOG ADD CONSTRAINT PK_LIMS_HOSPITAL_INTERFACE_LOG PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','INTERFACEID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','PARAMS','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','RESULT','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','INTERFACEID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','PARAMS','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','RESULT','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_HOSPITAL_INTERFACE_LOG','CREATEDBYORGNAME','1');
COMMIT;
CALL INSERTI18N('T_LIMS_HOSPITAL.SERVICE_NAME', '医院管理', '医院管理', 'zh-CN', '医院管理');
CALL INSERTI18N('T_LIMS_HOSPITAL.ID', '医院管理的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_HOSPITAL.HOSPITALCODE', '医院管理的医院编号', '医院编号', 'zh-CN', '医院编号');
CALL INSERTI18N('T_LIMS_HOSPITAL.HOSPITALNAME', '医院管理的医院名称', '医院名称', 'zh-CN', '医院名称');
CALL INSERTI18N('T_LIMS_HOSPITAL.PHONE', '医院管理的联系电话', '联系电话', 'zh-CN', '联系电话');
CALL INSERTI18N('T_LIMS_HOSPITAL.ADDRESS', '医院管理的地址', '地址', 'zh-CN', '地址');
CALL INSERTI18N('T_LIMS_HOSPITAL.REMARK', '医院管理的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_HOSPITAL.CREATEDBYID', '医院管理的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_HOSPITAL.CREATEDBYNAME', '医院管理的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_HOSPITAL.CREATEDTIME', '医院管理的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_HOSPITAL.CREATEDBYORGID', '医院管理的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_HOSPITAL.CREATEDBYORGNAME', '医院管理的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.SERVICE_NAME', '医院接口', '医院接口', 'zh-CN', '医院接口');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.ID', '医院接口的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.HOSPITALID', '医院接口的医院Id', '医院Id', 'zh-CN', '医院Id');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.APIID', '医院接口的接口Id', '接口Id', 'zh-CN', '接口Id');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.APICODE', '医院接口的接口编码', '接口编码', 'zh-CN', '接口编码');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.APINAME', '医院接口的接口名称', '接口名称', 'zh-CN', '接口名称');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.APITYPE', '医院接口的接口类型', '接口类型', 'zh-CN', '接口类型');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.PARAMS', '医院接口的参数', '参数', 'zh-CN', '参数');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.HANDLEMETHOD', '医院接口的接口调用方法', '接口调用方法', 'zh-CN', '接口调用方法');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.RESULTHANDLEMETHOD', '医院接口的结果处理方式', '结果处理方式', 'zh-CN', '结果处理方式');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.OPERATION', '医院接口的wsdl 方法名', 'wsdl 方法名', 'zh-CN', 'wsdl 方法名');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.REMARK', '医院接口的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.CREATEDBYID', '医院接口的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.CREATEDBYNAME', '医院接口的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.CREATEDTIME', '医院接口的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.CREATEDBYORGID', '医院接口的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE.CREATEDBYORGNAME', '医院接口的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.SERVICE_NAME', '接口数据源', '接口数据源', 'zh-CN', '接口数据源');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.ID', '接口数据源的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.INTERFACEID', '接口数据源的接口Id', '接口Id', 'zh-CN', '接口Id');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.SOURCECODE', '接口数据源的数据源编号', '数据源编号', 'zh-CN', '数据源编号');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.PARENTSOURCECODE', '接口数据源的父数据源编号', '父数据源编号', 'zh-CN', '父数据源编号');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.SOURCENAME', '接口数据源的数据源名称', '数据源名称', 'zh-CN', '数据源名称');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.SOURCETABLE', '接口数据源的数据源表', '数据源表', 'zh-CN', '数据源表');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.SOURCETYPE', '接口数据源的数据源类型', '数据源类型', 'zh-CN', '数据源类型');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.SQL', '接口数据源的sql', 'sql', 'zh-CN', 'sql');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.PARAM', '接口数据源的查询参数', '查询参数', 'zh-CN', '查询参数');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.CREATEDBYID', '接口数据源的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.CREATEDBYNAME', '接口数据源的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.CREATEDTIME', '接口数据源的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.CREATEDBYORGID', '接口数据源的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE.CREATEDBYORGNAME', '接口数据源的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.SERVICE_NAME', '接口数据源列', '接口数据源列', 'zh-CN', '接口数据源列');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.ID', '接口数据源列的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.SOURCEID', '接口数据源列的数据源Id', '数据源Id', 'zh-CN', '数据源Id');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.COLUMNNAME', '接口数据源列的列名', '列名', 'zh-CN', '列名');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.COLUMNDESC', '接口数据源列的列描述', '列描述', 'zh-CN', '列描述');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.REMARK', '接口数据源列的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.CREATEDBYID', '接口数据源列的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.CREATEDBYNAME', '接口数据源列的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.CREATEDTIME', '接口数据源列的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.CREATEDBYORGID', '接口数据源列的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_INTERFACE_SOURCE_COLUMN.CREATEDBYORGNAME', '接口数据源列的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.SERVICE_NAME', '接口参数', '接口参数', 'zh-CN', '接口参数');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.ID', '接口参数的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.INTERFACEID', '接口参数的接口Id', '接口Id', 'zh-CN', '接口Id');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.INDEX', '接口参数的序号', '序号', 'zh-CN', '序号');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.PARAM', '接口参数的参数', '参数', 'zh-CN', '参数');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.TYPE', '接口参数的类型', '类型', 'zh-CN', '类型');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.VALUE', '接口参数的值', '值', 'zh-CN', '值');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.CATEGORY', '接口参数的类别', '类别', 'zh-CN', '类别');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.CREATEDBYID', '接口参数的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.CREATEDBYNAME', '接口参数的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.CREATEDTIME', '接口参数的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.CREATEDBYORGID', '接口参数的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_PARAMS.CREATEDBYORGNAME', '接口参数的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_LOG.SERVICE_NAME', '接口日志', '接口日志', 'zh-CN', '接口日志');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_LOG.ID', '接口日志的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_LOG.INTERFACEID', '接口日志的接口ID', '接口ID', 'zh-CN', '接口ID');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_LOG.PARAMS', '接口日志的参数', '参数', 'zh-CN', '参数');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_LOG.RESULT', '接口日志的结果', '结果', 'zh-CN', '结果');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_LOG.CREATEDBYID', '接口日志的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_LOG.CREATEDBYNAME', '接口日志的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_LOG.CREATEDTIME', '接口日志的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_LOG.CREATEDBYORGID', '接口日志的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_HOSPITAL_INTERFACE_LOG.CREATEDBYORGNAME', '接口日志的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('BASEMODULE.RM.HOSPITALS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.RM.HOSPITALS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.RM.HOSPITALS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.RM.HOSPITALS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.RM.HOSPITALS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

-- 创建菜单语句
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('-1', '-1', '/secure/basemodule/rm/hospital-interface-paramss/page/edit-list', '-1', '-1', 'null', '-1');

INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_HOSPITAL', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_HOSPITAL_INTERFACE', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_INTERFACE_SOURCE', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_INTERFACE_SOURCE_COLUMN', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_HOSPITAL_INTERFACE_PARAMS', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_HOSPITAL_INTERFACE_LOG', '0', '0');


COMMIT;

-- ----------------------------- 2023-08-06 add by hul------------end